From b890b185ef8ae2a3ce329d656e23fd0db322c379 Mon Sep 17 00:00:00 2001
From: "Karl O. Pinc" <kop@karlpinc.com>
Date: Mon, 30 Sep 2024 09:29:46 -0500
Subject: [PATCH] Fix reset search_path button

---
 src/pgwui_sql/static/sql_edit.js     | 2 +-
 src/pgwui_sql/templates/sql_edit.mak | 7 +++++++
 2 files changed, 8 insertions(+), 1 deletion(-)

diff --git a/src/pgwui_sql/static/sql_edit.js b/src/pgwui_sql/static/sql_edit.js
index 6d86a3e..0cbb272 100644
--- a/src/pgwui_sql/static/sql_edit.js
+++ b/src/pgwui_sql/static/sql_edit.js
@@ -22,7 +22,7 @@
 */
 
 function showSearchPath() {
-  fetch('${request.route_path("pgwui_sql_db_search_path")|n}')
+  fetch(pgwuiSqlDbSearchPathRoute())
     .then((response) => {
           if (!response.ok) {
             window.alert('Problem obtaining the search_path');
diff --git a/src/pgwui_sql/templates/sql_edit.mak b/src/pgwui_sql/templates/sql_edit.mak
index d876e8a..d17c577 100644
--- a/src/pgwui_sql/templates/sql_edit.mak
+++ b/src/pgwui_sql/templates/sql_edit.mak
@@ -51,6 +51,13 @@
 
 <%inherit file="${sql_base_mak}" />
 
+<script>
+  // Functions for delivering "static" content that comes from templating.
+  function pgwuiSqlDbSearchPathRoute() {
+           return '${request.route_path("pgwui_sql_db_search_path")|n}';
+  }
+</script>
+
 <%block name="page_heading">
   SQL Entry Window
 </%block>
-- 
2.34.1